UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YRtPpHfA7MAEkg0mJWViVcun7hPx/1P5/L86Sbq14E='
WHERE
key_id = '7e59013bdf17e78dbb1509959c7fb00a2966bcde0eea3fdf385d83bd9fe252d8'
AND (
token = '3YRtPpHfA7MAEkg0mJWViVcun7hPx/1P5/L86Sbq14E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)