UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNUeAGi8GE7oH6jA3dspYs30PUly0BNZgXuXMGRZsUc='
WHERE
key_id = 'bddba8cda447dee01e4da8920c897cfbfadde39443c5c585f02c86c427627f4b'
AND (
token = 'VNUeAGi8GE7oH6jA3dspYs30PUly0BNZgXuXMGRZsUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)