UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cTes0aMDWsKyx/lnyb6R+5RByXpZPeLlhfpjrs8NUII='
WHERE
key_id = 'efe41950dcf1836bb4a42c0c712a1238a690c34eec55e30b72d3433a25caf5c2'
AND (
token = 'cTes0aMDWsKyx/lnyb6R+5RByXpZPeLlhfpjrs8NUII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)