UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZfLHJwZxc+borokHMESOZd6qv1fRW6IZWqA1lr9FGU='
WHERE
key_id = '48a64c3306d61347bf0e7db656627c3dc598eaacdce99b462faf757f198e7147'
AND (
token = 'fZfLHJwZxc+borokHMESOZd6qv1fRW6IZWqA1lr9FGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)