UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24jEp47nRgGw6skVkEIUsckMBa6f6mUy0k77Qol/eo4='
WHERE
key_id = '93abb0744e26cbfa1db0ea9c55776aa1baa49c5074d0f69730b55f75a8d952d8'
AND (
token = '24jEp47nRgGw6skVkEIUsckMBa6f6mUy0k77Qol/eo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)