UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gWi/V6HpHbJp9x1YGwLw5STPhbcK1UD7a7bXuSNiXo='
WHERE
key_id = '808a7ac4c882349a5f2441bc3393e6f443f2550ca3d49de459855ddd6988abee'
AND (
token = '1gWi/V6HpHbJp9x1YGwLw5STPhbcK1UD7a7bXuSNiXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)