UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cP1+lTIfAtHMJqq0IftrLNfWnPuChIaa4spZ8OD4Kng='
WHERE
key_id = 'e3fadbe450eba41be42b0d6bb009c4bbfb2d219d11d8c40c24aa5cc750a101fd'
AND (
token = 'cP1+lTIfAtHMJqq0IftrLNfWnPuChIaa4spZ8OD4Kng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)