UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'StxZ3roXeH74iHlCwc1Uu4/6xkp4/onySPDgF9aj8dA='
WHERE
key_id = '711810f659e5484376cd179e4b90831b048b5456f15d8f9bf96ffa959524bfa3'
AND (
token = 'StxZ3roXeH74iHlCwc1Uu4/6xkp4/onySPDgF9aj8dA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)