UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCAR/GovxeRpsYYBI2qb+d/lqxZBGTGadwraMcNeJRU='
WHERE
key_id = '189e28426538f9d3ebed1e010e2f48e008c65ee1bc244e0117cd3558163d8a16'
AND (
token = 'XCAR/GovxeRpsYYBI2qb+d/lqxZBGTGadwraMcNeJRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)