UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5m6KlxLpb+lOEDhAPhI64bX665bvEPx929lnYNS4nR4='
WHERE
key_id = 'deb450bd197a1c01636d88d599ad9eacfa88dfe5d5a521f2fb32d3a4a811713f'
AND (
token = '5m6KlxLpb+lOEDhAPhI64bX665bvEPx929lnYNS4nR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)