UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJ/C/9WHVtIFuIwJB8xPXqXejF0jfdsEoNkYn7EChvI='
WHERE
key_id = '867cdb44a33a7fa8032d415a3a847e237dbe4c6e0f17c2f06d267e8db12d7fe2'
AND (
token = 'XJ/C/9WHVtIFuIwJB8xPXqXejF0jfdsEoNkYn7EChvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)