UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgFiBV/kDKiNihNe8lv6T+rZHpRTHnWAF/lL7VgK814='
WHERE
key_id = 'd26ad9b4548c1535bcde63d0f24f030caf428c88fe5bdb1f381a93011c8c45e9'
AND (
token = 'ZgFiBV/kDKiNihNe8lv6T+rZHpRTHnWAF/lL7VgK814='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)