UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZzPZkuJMhg+J+YVFR8DSHwerUEFsRTSFYQ64kcmFGyU='
WHERE
key_id = '67928eeacb319e26535d19a373567f2d9bd818d823ca55d4a70cdacd07e00917'
AND (
token = 'ZzPZkuJMhg+J+YVFR8DSHwerUEFsRTSFYQ64kcmFGyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)