UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ivvL2fpGr758EBM+mqeEco0/4N+RagSG126c+F+8Zg='
WHERE
key_id = 'c1d742e5e0b194025bc68ff1ccc6e6e36e939541ed85d6656be86275ab6f0715'
AND (
token = '4ivvL2fpGr758EBM+mqeEco0/4N+RagSG126c+F+8Zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)