UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjfxqfFmIBCaKFrKde2BurDxZgB7V8BI+kWebA4aDxM='
WHERE
key_id = 'e909c6e58944a907a2ad989bd17b259736bc707e72d3fb8f914ea86805b86b0d'
AND (
token = 'XjfxqfFmIBCaKFrKde2BurDxZgB7V8BI+kWebA4aDxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)