UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46uMzdWun00Tgo7blwdDb/wZhiZ37iCI4TWMnK6HsU8='
WHERE
key_id = '1e84e7139281c5f175b7d477079c6f2226dac5e862b70c6e21d3f07cad0f14ca'
AND (
token = '46uMzdWun00Tgo7blwdDb/wZhiZ37iCI4TWMnK6HsU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)