UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nACh/1bzHQEhrg7IxMfUSmV/dZCIKUSUh0F8t36AVEg='
WHERE
key_id = 'e4c007de0368f014412882b5a72826e8bf329886b6972804a0b5705730ff6117'
AND (
token = 'nACh/1bzHQEhrg7IxMfUSmV/dZCIKUSUh0F8t36AVEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)