UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eWaXsKtz1e02dYAdGG9Q57kSLhwvZnCrPbBheC/wvl8='
WHERE
key_id = '6beea4d969f044f7f13d376ad0b462e344a651c7fb3a0417109de2277ea14b96'
AND (
token = 'eWaXsKtz1e02dYAdGG9Q57kSLhwvZnCrPbBheC/wvl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)