UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '53JPcrt77k8MAI5M3AT7ouXoizLVmZhpPKZbP9CqEcA='
WHERE
key_id = '4c9e71a5a7e3e8be7f60c4f9beb94052b6db44c8dd8b9b612830302db72f969a'
AND (
token = '53JPcrt77k8MAI5M3AT7ouXoizLVmZhpPKZbP9CqEcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)