UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'StfGT0oh/1DB51KIm2DZwRihuGR7Qx8plEU+v7Oget0='
WHERE
key_id = 'a672e6eba038cba7554757d3b927c67495851845e645d7a4117f0122f44befc5'
AND (
token = 'StfGT0oh/1DB51KIm2DZwRihuGR7Qx8plEU+v7Oget0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)