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