UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zic7LD8rmdlvD24u7lMzszWyJrgzJ+7Pbxc2uoXZN/w='
WHERE
key_id = 'd83b46d0ba688b7c97a406476e25535582bbea197bdf4e70571ab8c3d953a562'
AND (
token = 'Zic7LD8rmdlvD24u7lMzszWyJrgzJ+7Pbxc2uoXZN/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)