UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'As4vGBjAZHHZI1hKlxCity9M2e7W9BF2Js0nBVJESog='
WHERE
key_id = '4341f2f9e7372c0ab498e4f90d3f8b0112281909940e501613aae8ad55d61da2'
AND (
token = 'As4vGBjAZHHZI1hKlxCity9M2e7W9BF2Js0nBVJESog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)