UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7E8zdd9Y3tVXoCL0UJFcVzhB6ZphqqxjOOV6AmtfH2Q='
WHERE
key_id = '4767d95e17f2777398174fd40fd9b57ae9de05d70aaa1c9ce9d81fe3a0160f60'
AND (
token = '7E8zdd9Y3tVXoCL0UJFcVzhB6ZphqqxjOOV6AmtfH2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)