UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CWzkzNow54vYkAmoKA6U2m1gMw4keyKavV7BXS5AwC4='
WHERE
key_id = 'a1f3547cd357c26f8a197bfb0190cb9a6fee5fc79f90d1ca545e7f8a9112b177'
AND (
token = 'CWzkzNow54vYkAmoKA6U2m1gMw4keyKavV7BXS5AwC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)