UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXATvzmqWpSvm0xuu5oj3Cax1zraGAhiAqD+QltwzfQ='
WHERE
key_id = '7f8c9ffa061c068dfb13fdb7eac0d7841d4ded32df3607f7baeb9947313674de'
AND (
token = 'PXATvzmqWpSvm0xuu5oj3Cax1zraGAhiAqD+QltwzfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)