UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNW1lBw8V7H6R1KLe2zw5zWfxwGBLSWbSNZSgzGPujA='
WHERE
key_id = 'edfd2bc26631fe6422a4b04eef3ddd3acdb843818e679141495e9d8b212eaf0f'
AND (
token = 'NNW1lBw8V7H6R1KLe2zw5zWfxwGBLSWbSNZSgzGPujA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)