UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Klg6s2DoXbJFdhcfozLw4SVabCRLhHdju1rKntaxKc8='
WHERE
key_id = 'e488f3f745a0c5f94f541c188b2a22a1953fd44abb0752bf2fb68f8068ca9077'
AND (
token = 'Klg6s2DoXbJFdhcfozLw4SVabCRLhHdju1rKntaxKc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)