UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X32Khj36scj+7btL8oIedf+EmVVBDjJTDUdTtnI+mWo='
WHERE
key_id = '9268c8f50a21e32897133b3e69758f61edd897c7278c6c22a16075cc05831398'
AND (
token = 'X32Khj36scj+7btL8oIedf+EmVVBDjJTDUdTtnI+mWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)