UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LlD6gZK4Zp7SvWRcbV3mMUJA1QSWE7ZD7pvyNUAu3WI='
WHERE
key_id = '1c2eb0c21d61d3f39f324b69e70ef323a59f3b7319cd4abfe5d16e87905fecf3'
AND (
token = 'LlD6gZK4Zp7SvWRcbV3mMUJA1QSWE7ZD7pvyNUAu3WI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)