UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jVvCgtn8m4DHEXG55CppXoX1iZgUalVdSMOANtIO9M='
WHERE
key_id = '84ff8858e946075b52c48e030bf1b150a87a29297dc60d2e992167c4043ee499'
AND (
token = '0jVvCgtn8m4DHEXG55CppXoX1iZgUalVdSMOANtIO9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)