UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B+rBw1AJwNBhPnXq4HaMtbtX+UljAAHufVC8UBsHGP8='
WHERE
key_id = 'cb5f99aa44e0dcba9a03b942ff4e4cd8f1535b04d07314d926563ee3b6ed7f36'
AND (
token = 'B+rBw1AJwNBhPnXq4HaMtbtX+UljAAHufVC8UBsHGP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)