UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHFWorv+ndtrvObWQN3qndE+Sn7ZURdrnCC6oC8HPO4='
WHERE
key_id = '1985f72515236aa36c9bcb136e8c3466aeef6fff80fa0130adca92a8e1d2fe19'
AND (
token = 'hHFWorv+ndtrvObWQN3qndE+Sn7ZURdrnCC6oC8HPO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)