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