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