UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxW+85NNuZWYJKFXJjBWwuHZHySSap4o44gjZzGhmEo='
WHERE
key_id = '15bed40f8fadc21286fe32ad45890225649a5f4ff442318b017f1144fcc3934a'
AND (
token = 'zxW+85NNuZWYJKFXJjBWwuHZHySSap4o44gjZzGhmEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)