UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJCONg8LeVC2Cq3CZXaAHuYchquX5MWbV2pjeX8JyYA='
WHERE
key_id = '8de75be1dc19d271465beb42038c028e90ffdb92f14015dc9456beff010b5fdd'
AND (
token = 'DJCONg8LeVC2Cq3CZXaAHuYchquX5MWbV2pjeX8JyYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)