UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HLpKcgw4Bu89aHv0T/dfRmcPR2nitYc34lxfPA5z/Vo='
WHERE
key_id = 'c4d318e86b890722d9a7844ee2b0efc95aa47e0ad9746e40fea67ba7745047ab'
AND (
token = 'HLpKcgw4Bu89aHv0T/dfRmcPR2nitYc34lxfPA5z/Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)