UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gr9zcEtIGVToIjW1kY7quEBNdBCom90VExkkgfihvOg='
WHERE
key_id = '0c9bd681ab3c82202f1f2ff38ff7c443a9a55ce4967c1952f4bf35599ec59e07'
AND (
token = 'Gr9zcEtIGVToIjW1kY7quEBNdBCom90VExkkgfihvOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)